Open topic with navigation

Configuring external datasheets

QA Wizard Pro can retrieve test data from external sources, including Microsoft Access, Microsoft Excel, Microsoft SQL Server, Oracle, PostgreSQL, SQLite, and text files. There are two options for retrieving external data: importing data from an external source or linking to external data.

If you want to copy test data into a datasheet and change it in QA Wizard Pro without modifying data in the external source, import the test data from the external source. After the data is imported to QA Wizard Pro, you can modify it locally to test different scenarios. See Importing external test data.

If you want to sync the data between the external source and QA Wizard Pro, link to the data. When changes are made in the external source, data in the linked datasheet is automatically updated and vice versa. See Linking to external test data.